{
  "statement": "select p1.col2 \n ,p3.cust_cn_name \n ,p2.cust_mgr_name \n ,p1.col1 \n ,p2.mgmt_org_name \n ,p4.org_no \n ,SUM(p1.cvt_rmb_txn_amt) as cvt_rmb_txn_amt \n from test_db1.tbl_1 p1 \n inner join \n ( select col2 , ETL_DT\n from test_db1.tbl_1 p1 \n where p1.debit_crdt_flag = '02' \n group by 1, 2\n having sum(p1.cvt_rmb_txn_amt) >= 500000 \n ) p5 \n on p1.col2=p5.col2 and p1.ETL_DT=p5.ETL_DT\n left join test_db1.tbl_2 p2 \n on p2.cust_mgmt_type_cd ='1' \n and p1.col2 = p2.col2 \n and p2.start_dt <= p1.ETL_DT\n and p2.end_dt > p1.ETL_DT\n left join test_db2.tbl_3 p3 \n on p1.col2 = p3.col2 \n and p3.etl_dt = p1.ETL_DT\n left join test_db2.tbl_4 p4 \n on p1.col1=p4.acct_org_no \n and p4.etl_dt = p1.ETL_DT\n where p1.debit_crdt_flag = '02' \n and p1.ETL_DT = '2023-03-31'\n and p4.org_no = '200105085'\n group by 1,2,3,4,5,6 \n order by p1.col2\n limit 0, 100",
  "table_meta": {
    "test_db1.tbl_1": "CREATE TABLE `tbl_1` (\n `etl_dt` date NULL COMMENT \"etl\",\n `lp_org_no` varchar(90) NULL COMMENT \"\",\n `col2` varchar(240) NULL COMMENT \"\",\n `debit_crdt_flag` varchar(30) NULL COMMENT \"\",\n `txn_type_cd` varchar(30) NULL COMMENT \"\",\n `txn_chnl_cd` varchar(30) NULL COMMENT \"\",\n `txn_cd` varchar(90) NULL COMMENT \"\",\n `acct_no` varchar(180) NULL COMMENT \"\",\n `col1` varchar(60) NULL COMMENT \"\",\n `curr_cd` varchar(60) NULL COMMENT \"\",\n `txn_dt` varchar(30) NULL COMMENT \"\",\n `txn_amt` decimal128(22, 2) NULL COMMENT \"\",\n `cvt_rmb_txn_amt` decimal128(22, 2) NULL COMMENT \"\",\n `txn_cnt` decimal128(22, 0) NULL COMMENT \"\"\n) ENGINE=OLAP \nDUPLICATE KEY(`etl_dt`, `lp_org_no`, `col2`)\nCOMMENT \"\"\nPARTITION BY RANGE(`etl_dt`)\n(PARTITION p20221230 VALUES [(\"2022-12-30\"), (\"2022-12-31\")),\nPARTITION p20230331 VALUES [(\"2023-03-31\"), (\"2023-04-01\")))\nDISTRIBUTED BY HASH(`etl_dt`, `col2`) BUCKETS 1 \nPROPERTIES (\n\"replication_num\" = \"1\",\n\"in_memory\" = \"false\",\n\"storage_format\" = \"DEFAULT\",\n\"enable_persistent_index\" = \"false\",\n\"compression\" = \"LZ4\"\n);",
    "test_db1.tbl_2": "CREATE TABLE `tbl_2` (\n `start_dt` date NULL COMMENT \"\",\n `end_dt` date NULL COMMENT \"\",\n `lp_org_no` varchar(90) NULL COMMENT \"\",\n `cust_mgmt_type_cd` varchar(60) NULL COMMENT \"\",\n `col2` varchar(240) NULL COMMENT \"ecif\",\n `mgmt_org_no` varchar(60) NULL COMMENT \"\",\n `cust_mgr_no` varchar(90) NULL COMMENT \"\",\n `cust_mgr_name` varchar(90) NULL COMMENT \"\",\n `acct_org_no` varchar(60) NULL COMMENT \"\",\n `acct_org_name` varchar(90) NULL COMMENT \"\",\n `mgmt_org_name` varchar(90) NULL COMMENT \"\"\n) ENGINE=OLAP \nDUPLICATE KEY(`start_dt`, `end_dt`, `lp_org_no`)\nCOMMENT \"\"\nDISTRIBUTED BY HASH(`start_dt`, `end_dt`, `cust_mgmt_type_cd`, `col2`, `mgmt_org_no`, `cust_mgr_no`) BUCKETS 50 \nPROPERTIES (\n\"replication_num\" = \"1\",\n\"in_memory\" = \"false\",\n\"storage_format\" = \"DEFAULT\",\n\"enable_persistent_index\" = \"false\",\n\"compression\" = \"LZ4\"\n);",
    "test_db2.tbl_3": "CREATE TABLE `tbl_3` (\n `etl_dt` date NULL COMMENT \"\",\n `col2` varchar(240) NULL COMMENT \"\",\n `lp_org_no` varchar(90) NULL COMMENT \"\",\n `cust_cn_name` varchar(900) NULL COMMENT \"\",\n `surname` varchar(300) NULL COMMENT \"()\",\n `first_name` varchar(300) NULL COMMENT \"()\",\n `indv_cust_src_cd` varchar(60) NULL COMMENT \"\",\n `cust_no_status` varchar(180) NULL COMMENT \"\",\n `cust_no_status_chg_dt` varchar(30) NULL COMMENT \"\",\n `cust_label` varchar(180) NULL COMMENT \"KYC\",\n `cust_label_update_dt` varchar(30) NULL COMMENT \"KYC\",\n `birth_dt` varchar(30) NULL COMMENT \"\",\n `age` decimal128(22, 0) NULL COMMENT \"\",\n `birthplace_cn_dist_cd` varchar(60) NULL COMMENT \"\",\n `gender_cd` varchar(60) NULL COMMENT \"\",\n `nation_cd` varchar(60) NULL COMMENT \"\",\n `ethnic_cd` varchar(60) NULL COMMENT \"\",\n `marri_status_cd` varchar(60) NULL COMMENT \"\",\n `dwlg_situ_cd` varchar(60) NULL COMMENT \"\",\n `tax_resdnt_type_cd` varchar(60) NULL COMMENT \"\",\n `doctyp_cd` varchar(60) NULL COMMENT \"\",\n `doc_no` varchar(180) NULL COMMENT \"\",\n `lics_issue_dt` varchar(30) NULL COMMENT \"\",\n `lic_auth_name` varchar(300) NULL COMMENT \"\",\n `lic_auth_ctry_rgn_cd` varchar(60) NULL COMMENT \"\",\n `doc_expir_dt` varchar(30) NULL COMMENT \"\",\n `doc_addr` varchar(900) NULL COMMENT \"\",\n `tel_no` varchar(90) NULL COMMENT \"\",\n `fix_tel_no` varchar(180) NULL COMMENT \"\",\n `resdn_addr` varchar(3000) NULL COMMENT \"\",\n `edu_bkg_cd` varchar(60) NULL COMMENT \"\",\n `academ_deg_cd` varchar(60) NULL COMMENT \"\",\n `career_cd` varchar(60) NULL COMMENT \"\",\n `empl_cond_cd` varchar(3000) NULL COMMENT \"\",\n `emply_blg_indus_cd` varchar(60) NULL COMMENT \"\",\n `cont_addr` varchar(3000) NULL COMMENT \"\",\n `curr_emplyer_name` varchar(300) NULL COMMENT \"\",\n `emplyer_propty_cd` varchar(30) NULL COMMENT \"\",\n `position_cd` varchar(60) NULL COMMENT \"\",\n `title_cd` varchar(60) NULL COMMENT \"\",\n `indv_cust_type_subdv_cd` varchar(30) NULL COMMENT \"\",\n `spouse_name` varchar(900) NULL COMMENT \"\",\n `spouse_tel_no` varchar(900) NULL COMMENT \"\",\n `dwlg_address` varchar(900) NULL COMMENT \"\",\n `indv_anl_income` decimal128(22, 2) NULL COMMENT \"\",\n `family_anl_income` decimal128(22, 2) NULL COMMENT \"\",\n `payoff_salary_corp_name` varchar(300) NULL COMMENT \"\",\n `pbank_key_pot_cust_mgmt_flag` varchar(30) NULL COMMENT \"\",\n `hsekp_emply_id` varchar(180) NULL COMMENT \"\",\n `hsekp_name` varchar(300) NULL COMMENT \"\",\n `obank_emply_flag` varchar(30) NULL COMMENT \"\",\n `cust_belong_org_no` varchar(240) NULL COMMENT \"\",\n `cust_risk_lvl_cd` varchar(60) NULL COMMENT \"\",\n `bnkoutls_risk_estim_flag` varchar(30) NULL COMMENT \"\",\n `cust_ml_risk_ass_reslt_cd` varchar(30) NULL COMMENT \"\",\n `cust_ltst_ml_risk_ass_dvd_dt` varchar(30) NULL COMMENT \"\",\n `aml_blklist_flag` varchar(30) NULL COMMENT \"\",\n `farmers_flag` varchar(30) NULL COMMENT \"\",\n `overs_cust_flag` varchar(30) NULL COMMENT \"\",\n `cust_no_crt_sys_cd` varchar(180) NULL COMMENT \"\",\n `cust_no_create_dt` varchar(30) NULL COMMENT \"\",\n `cust_no_crt_ins_no` varchar(240) NULL COMMENT \"\",\n `cust_no_crt_emp_no` varchar(90) NULL COMMENT \"\",\n `rcnt_update_cust_info_dt` varchar(30) NULL COMMENT \"\",\n `rcnt_update_cust_info_sys_cd` varchar(60) NULL COMMENT \"\",\n `rcnt_update_cust_info_inst_no` varchar(240) NULL COMMENT \"\",\n `rcnt_update_cust_info_emp_no` varchar(90) NULL COMMENT \"\",\n `mobile_no_effectns_label_cd` varchar(60) NULL COMMENT \"\",\n `cpr_mbl_no_rl_nm_vr_rst_cd` varchar(60) NULL COMMENT \"\"\n) ENGINE=OLAP \nDUPLICATE KEY(`etl_dt`, `col2`, `lp_org_no`)\nCOMMENT \"\"\nPARTITION BY RANGE(`etl_dt`)\n(PARTITION p20191230 VALUES [(\"2019-12-30\"), (\"2019-12-31\")),\nPARTITION p20200131 VALUES [(\"2020-01-31\"), (\"2020-02-01\")),\nPARTITION p20200229 VALUES [(\"2020-02-29\"), (\"2020-03-01\")),\nPARTITION p20200331 VALUES [(\"2020-03-31\"), (\"2020-04-01\")),\nPARTITION p20200430 VALUES [(\"2020-04-30\"), (\"2020-05-01\")),\nPARTITION p20200531 VALUES [(\"2020-05-31\"), (\"2020-06-01\")),\nPARTITION p20200630 VALUES [(\"2020-06-30\"), (\"2020-07-01\")),\nPARTITION p20200731 VALUES [(\"2020-07-31\"), (\"2020-08-01\")),\nPARTITION p20200831 VALUES [(\"2020-08-31\"), (\"2020-09-01\")),\nPARTITION p20200930 VALUES [(\"2020-09-30\"), (\"2020-10-01\")),\nPARTITION p20201031 VALUES [(\"2020-10-31\"), (\"2020-11-01\")),\nPARTITION p20201130 VALUES [(\"2020-11-30\"), (\"2020-12-01\")),\nPARTITION p20201231 VALUES [(\"2020-12-31\"), (\"2021-01-01\")),\nPARTITION p20210131 VALUES [(\"2021-01-31\"), (\"2021-02-01\")),\nPARTITION p20210228 VALUES [(\"2021-02-28\"), (\"2021-03-01\")),\nPARTITION p20210331 VALUES [(\"2021-03-31\"), (\"2021-04-01\")),\nPARTITION p20210430 VALUES [(\"2021-04-30\"), (\"2021-05-01\")),\nPARTITION p20210531 VALUES [(\"2021-05-31\"), (\"2021-06-01\")),\nPARTITION p20210630 VALUES [(\"2021-06-30\"), (\"2021-07-01\")),\nPARTITION p20210731 VALUES [(\"2021-07-31\"), (\"2021-08-01\")),\nPARTITION p20210831 VALUES [(\"2021-08-31\"), (\"2021-09-01\")),\nPARTITION p20210930 VALUES [(\"2021-09-30\"), (\"2021-10-01\")),\nPARTITION p20211031 VALUES [(\"2021-10-31\"), (\"2021-11-01\")),\nPARTITION p20211130 VALUES [(\"2021-11-30\"), (\"2021-12-01\")),\nPARTITION p20211231 VALUES [(\"2021-12-31\"), (\"2022-01-01\")),\nPARTITION p20220131 VALUES [(\"2022-01-31\"), (\"2022-02-01\")),\nPARTITION p20220228 VALUES [(\"2022-02-28\"), (\"2022-03-01\")),\nPARTITION p20220331 VALUES [(\"2022-03-31\"), (\"2022-04-01\")),\nPARTITION p20220430 VALUES [(\"2022-04-30\"), (\"2022-05-01\")),\nPARTITION p20220531 VALUES [(\"2022-05-31\"), (\"2022-06-01\")),\nPARTITION p20220630 VALUES [(\"2022-06-30\"), (\"2022-07-01\")),\nPARTITION p20220731 VALUES [(\"2022-07-31\"), (\"2022-08-01\")),\nPARTITION p20220831 VALUES [(\"2022-08-31\"), (\"2022-09-01\")),\nPARTITION p20220930 VALUES [(\"2022-09-30\"), (\"2022-10-01\")),\nPARTITION p20221031 VALUES [(\"2022-10-31\"), (\"2022-11-01\")),\nPARTITION p20221130 VALUES [(\"2022-11-30\"), (\"2022-12-01\")),\nPARTITION p20221231 VALUES [(\"2022-12-31\"), (\"2023-01-01\")),\nPARTITION p20230131 VALUES [(\"2023-01-31\"), (\"2023-02-01\")),\nPARTITION p20230228 VALUES [(\"2023-02-28\"), (\"2023-03-01\")),\nPARTITION p20230331 VALUES [(\"2023-03-31\"), (\"2023-04-01\")),\nPARTITION p20230407 VALUES [(\"2023-04-07\"), (\"2023-04-08\")),\nPARTITION p20230408 VALUES [(\"2023-04-08\"), (\"2023-04-09\")),\nPARTITION p20230409 VALUES [(\"2023-04-09\"), (\"2023-04-10\")),\nPARTITION p20230410 VALUES [(\"2023-04-10\"), (\"2023-04-11\")),\nPARTITION p20230411 VALUES [(\"2023-04-11\"), (\"2023-04-12\")),\nPARTITION p20230412 VALUES [(\"2023-04-12\"), (\"2023-04-13\")),\nPARTITION p20230413 VALUES [(\"2023-04-13\"), (\"2023-04-14\")),\nPARTITION p20230414 VALUES [(\"2023-04-14\"), (\"2023-04-15\")),\nPARTITION p20230415 VALUES [(\"2023-04-15\"), (\"2023-04-16\")),\nPARTITION p20230416 VALUES [(\"2023-04-16\"), (\"2023-04-17\")),\nPARTITION p20230417 VALUES [(\"2023-04-17\"), (\"2023-04-18\")),\nPARTITION p20230418 VALUES [(\"2023-04-18\"), (\"2023-04-19\")),\nPARTITION p20230419 VALUES [(\"2023-04-19\"), (\"2023-04-20\")),\nPARTITION p20230420 VALUES [(\"2023-04-20\"), (\"2023-04-21\")),\nPARTITION p20230421 VALUES [(\"2023-04-21\"), (\"2023-04-22\")),\nPARTITION p20230422 VALUES [(\"2023-04-22\"), (\"2023-04-23\")),\nPARTITION p20230423 VALUES [(\"2023-04-23\"), (\"2023-04-24\")),\nPARTITION p20230424 VALUES [(\"2023-04-24\"), (\"2023-04-25\")),\nPARTITION p20230425 VALUES [(\"2023-04-25\"), (\"2023-04-26\")),\nPARTITION p20230426 VALUES [(\"2023-04-26\"), (\"2023-04-27\")),\nPARTITION p20230427 VALUES [(\"2023-04-27\"), (\"2023-04-28\")),\nPARTITION p20230428 VALUES [(\"2023-04-28\"), (\"2023-04-29\")),\nPARTITION p20230429 VALUES [(\"2023-04-29\"), (\"2023-04-30\")),\nPARTITION p20230430 VALUES [(\"2023-04-30\"), (\"2023-05-01\")),\nPARTITION p20230501 VALUES [(\"2023-05-01\"), (\"2023-05-02\")),\nPARTITION p20230502 VALUES [(\"2023-05-02\"), (\"2023-05-03\")),\nPARTITION p20230503 VALUES [(\"2023-05-03\"), (\"2023-05-04\")),\nPARTITION p20230504 VALUES [(\"2023-05-04\"), (\"2023-05-05\")),\nPARTITION p20230505 VALUES [(\"2023-05-05\"), (\"2023-05-06\")),\nPARTITION p20230506 VALUES [(\"2023-05-06\"), (\"2023-05-07\")),\nPARTITION p20230507 VALUES [(\"2023-05-07\"), (\"2023-05-08\")),\nPARTITION p20230508 VALUES [(\"2023-05-08\"), (\"2023-05-09\")),\nPARTITION p20230509 VALUES [(\"2023-05-09\"), (\"2023-05-10\")),\nPARTITION p20230510 VALUES [(\"2023-05-10\"), (\"2023-05-11\")),\nPARTITION p20230511 VALUES [(\"2023-05-11\"), (\"2023-05-12\")),\nPARTITION p20230512 VALUES [(\"2023-05-12\"), (\"2023-05-13\")),\nPARTITION p20230513 VALUES [(\"2023-05-13\"), (\"2023-05-14\")),\nPARTITION p20230514 VALUES [(\"2023-05-14\"), (\"2023-05-15\")),\nPARTITION p20230515 VALUES [(\"2023-05-15\"), (\"2023-05-16\")),\nPARTITION p20230516 VALUES [(\"2023-05-16\"), (\"2023-05-17\")),\nPARTITION p20230517 VALUES [(\"2023-05-17\"), (\"2023-05-18\")),\nPARTITION p20230518 VALUES [(\"2023-05-18\"), (\"2023-05-19\")),\nPARTITION p20230519 VALUES [(\"2023-05-19\"), (\"2023-05-20\")),\nPARTITION p20230520 VALUES [(\"2023-05-20\"), (\"2023-05-21\")),\nPARTITION p20230521 VALUES [(\"2023-05-21\"), (\"2023-05-22\")),\nPARTITION p20230522 VALUES [(\"2023-05-22\"), (\"2023-05-23\")),\nPARTITION p20230523 VALUES [(\"2023-05-23\"), (\"2023-05-24\")),\nPARTITION p20230524 VALUES [(\"2023-05-24\"), (\"2023-05-25\")),\nPARTITION p20230525 VALUES [(\"2023-05-25\"), (\"2023-05-26\")),\nPARTITION p20230526 VALUES [(\"2023-05-26\"), (\"2023-05-27\")),\nPARTITION p20230527 VALUES [(\"2023-05-27\"), (\"2023-05-28\")),\nPARTITION p20230528 VALUES [(\"2023-05-28\"), (\"2023-05-29\")),\nPARTITION p20230529 VALUES [(\"2023-05-29\"), (\"2023-05-30\")),\nPARTITION p20230530 VALUES [(\"2023-05-30\"), (\"2023-05-31\")),\nPARTITION p20230531 VALUES [(\"2023-05-31\"), (\"2023-06-01\")),\nPARTITION p20230601 VALUES [(\"2023-06-01\"), (\"2023-06-02\")),\nPARTITION p20230602 VALUES [(\"2023-06-02\"), (\"2023-06-03\")),\nPARTITION p20230603 VALUES [(\"2023-06-03\"), (\"2023-06-04\")),\nPARTITION p20230604 VALUES [(\"2023-06-04\"), (\"2023-06-05\")),\nPARTITION p20230605 VALUES [(\"2023-06-05\"), (\"2023-06-06\")),\nPARTITION p20230606 VALUES [(\"2023-06-06\"), (\"2023-06-07\")),\nPARTITION p20230607 VALUES [(\"2023-06-07\"), (\"2023-06-08\")),\nPARTITION p20230608 VALUES [(\"2023-06-08\"), (\"2023-06-09\")),\nPARTITION p20230609 VALUES [(\"2023-06-09\"), (\"2023-06-10\")),\nPARTITION p20230610 VALUES [(\"2023-06-10\"), (\"2023-06-11\")),\nPARTITION p20230611 VALUES [(\"2023-06-11\"), (\"2023-06-12\")),\nPARTITION p20230612 VALUES [(\"2023-06-12\"), (\"2023-06-13\")),\nPARTITION p20230613 VALUES [(\"2023-06-13\"), (\"2023-06-14\")),\nPARTITION p20230614 VALUES [(\"2023-06-14\"), (\"2023-06-15\")),\nPARTITION p20230615 VALUES [(\"2023-06-15\"), (\"2023-06-16\")),\nPARTITION p20230616 VALUES [(\"2023-06-16\"), (\"2023-06-17\")),\nPARTITION p20230617 VALUES [(\"2023-06-17\"), (\"2023-06-18\")),\nPARTITION p20230618 VALUES [(\"2023-06-18\"), (\"2023-06-19\")),\nPARTITION p20230619 VALUES [(\"2023-06-19\"), (\"2023-06-20\")),\nPARTITION p20230620 VALUES [(\"2023-06-20\"), (\"2023-06-21\")),\nPARTITION p20230621 VALUES [(\"2023-06-21\"), (\"2023-06-22\")),\nPARTITION p20230622 VALUES [(\"2023-06-22\"), (\"2023-06-23\")),\nPARTITION p20230623 VALUES [(\"2023-06-23\"), (\"2023-06-24\")),\nPARTITION p20230624 VALUES [(\"2023-06-24\"), (\"2023-06-25\")),\nPARTITION p20230625 VALUES [(\"2023-06-25\"), (\"2023-06-26\")),\nPARTITION p20230626 VALUES [(\"2023-06-26\"), (\"2023-06-27\")),\nPARTITION p20230627 VALUES [(\"2023-06-27\"), (\"2023-06-28\")),\nPARTITION p20230628 VALUES [(\"2023-06-28\"), (\"2023-06-29\")),\nPARTITION p20230629 VALUES [(\"2023-06-29\"), (\"2023-06-30\")),\nPARTITION p20230630 VALUES [(\"2023-06-30\"), (\"2023-07-01\")),\nPARTITION p20230701 VALUES [(\"2023-07-01\"), (\"2023-07-02\")),\nPARTITION p20230702 VALUES [(\"2023-07-02\"), (\"2023-07-03\")),\nPARTITION p20230703 VALUES [(\"2023-07-03\"), (\"2023-07-04\")),\nPARTITION p20230704 VALUES [(\"2023-07-04\"), (\"2023-07-05\")),\nPARTITION p20230705 VALUES [(\"2023-07-05\"), (\"2023-07-06\")),\nPARTITION p20230706 VALUES [(\"2023-07-06\"), (\"2023-07-07\")),\nPARTITION p20230707 VALUES [(\"2023-07-07\"), (\"2023-07-08\")))\nDISTRIBUTED BY HASH(`etl_dt`, `col2`, `lp_org_no`) BUCKETS 25 \nPROPERTIES (\n\"replication_num\" = \"1\",\n\"in_memory\" = \"false\",\n\"storage_format\" = \"DEFAULT\",\n\"enable_persistent_index\" = \"false\",\n\"compression\" = \"LZ4\"\n);",
    "test_db2.tbl_4": "CREATE TABLE `tbl_4` (\n `etl_dt` date NULL COMMENT \"\",\n `org_no` varchar(240) NULL COMMENT \"\",\n `org_name` varchar(300) NULL COMMENT \"\",\n `org_type_cd` varchar(60) NULL COMMENT \"\",\n `org_lvl_cd` varchar(60) NULL COMMENT \"\",\n `super_org_no` varchar(240) NULL COMMENT \"\",\n `super_org_name` varchar(300) NULL COMMENT \"\",\n `lvl_one_org_no` varchar(240) NULL COMMENT \"\",\n `lvl_one_org_name` varchar(300) NULL COMMENT \"\",\n `lvl_two_org_no` varchar(240) NULL COMMENT \"\",\n `lvl_two_org_name` varchar(300) NULL COMMENT \"\",\n `lvl_three_org_no` varchar(240) NULL COMMENT \"\",\n `lvl_three_org_name` varchar(300) NULL COMMENT \"\",\n `lvl_four_org_no` varchar(240) NULL COMMENT \"\",\n `lvl_four_org_name` varchar(300) NULL COMMENT \"\",\n `acct_org_no` varchar(240) NULL COMMENT \"\",\n `stop_use_flag` varchar(30) NULL COMMENT \"\",\n `org_type_cbirc_cd` varchar(60) NULL COMMENT \"_\"\n) ENGINE=OLAP \nDUPLICATE KEY(`etl_dt`, `org_no`)\nCOMMENT \"\"\nPARTITION BY RANGE(`etl_dt`)\n(PARTITION p201812 VALUES [(\"2018-12-30\"), (\"2019-01-01\")),\nPARTITION p201901 VALUES [(\"2019-01-01\"), (\"2019-02-01\")),\nPARTITION p201902 VALUES [(\"2019-02-01\"), (\"2019-03-01\")),\nPARTITION p201903 VALUES [(\"2019-03-01\"), (\"2019-04-01\")),\nPARTITION p201904 VALUES [(\"2019-04-01\"), (\"2019-05-01\")),\nPARTITION p201905 VALUES [(\"2019-05-01\"), (\"2019-06-01\")),\nPARTITION p201906 VALUES [(\"2019-06-01\"), (\"2019-07-01\")),\nPARTITION p201907 VALUES [(\"2019-07-01\"), (\"2019-08-01\")),\nPARTITION p201908 VALUES [(\"2019-08-01\"), (\"2019-09-01\")),\nPARTITION p201909 VALUES [(\"2019-09-01\"), (\"2019-10-01\")),\nPARTITION p201910 VALUES [(\"2019-10-01\"), (\"2019-11-01\")),\nPARTITION p201911 VALUES [(\"2019-11-01\"), (\"2019-12-01\")),\nPARTITION p201912 VALUES [(\"2019-12-01\"), (\"2020-01-01\")),\nPARTITION p202001 VALUES [(\"2020-01-01\"), (\"2020-02-01\")),\nPARTITION p202002 VALUES [(\"2020-02-01\"), (\"2020-03-01\")),\nPARTITION p202003 VALUES [(\"2020-03-01\"), (\"2020-04-01\")),\nPARTITION p202004 VALUES [(\"2020-04-01\"), (\"2020-05-01\")),\nPARTITION p202005 VALUES [(\"2020-05-01\"), (\"2020-06-01\")),\nPARTITION p202006 VALUES [(\"2020-06-01\"), (\"2020-07-01\")),\nPARTITION p202007 VALUES [(\"2020-07-01\"), (\"2020-08-01\")),\nPARTITION p202008 VALUES [(\"2020-08-01\"), (\"2020-09-01\")),\nPARTITION p202009 VALUES [(\"2020-09-01\"), (\"2020-10-01\")),\nPARTITION p202010 VALUES [(\"2020-10-01\"), (\"2020-11-01\")),\nPARTITION p202011 VALUES [(\"2020-11-01\"), (\"2020-12-01\")),\nPARTITION p202012 VALUES [(\"2020-12-01\"), (\"2021-01-01\")),\nPARTITION p202101 VALUES [(\"2021-01-01\"), (\"2021-02-01\")),\nPARTITION p202102 VALUES [(\"2021-02-01\"), (\"2021-03-01\")),\nPARTITION p202103 VALUES [(\"2021-03-01\"), (\"2021-04-01\")),\nPARTITION p202104 VALUES [(\"2021-04-01\"), (\"2021-05-01\")),\nPARTITION p202105 VALUES [(\"2021-05-01\"), (\"2021-06-01\")),\nPARTITION p202106 VALUES [(\"2021-06-01\"), (\"2021-07-01\")),\nPARTITION p202107 VALUES [(\"2021-07-01\"), (\"2021-08-01\")),\nPARTITION p202108 VALUES [(\"2021-08-01\"), (\"2021-09-01\")),\nPARTITION p202109 VALUES [(\"2021-09-01\"), (\"2021-10-01\")),\nPARTITION p202110 VALUES [(\"2021-10-01\"), (\"2021-11-01\")),\nPARTITION p202111 VALUES [(\"2021-11-01\"), (\"2021-12-01\")),\nPARTITION p202112 VALUES [(\"2021-12-01\"), (\"2022-01-01\")),\nPARTITION p202201 VALUES [(\"2022-01-01\"), (\"2022-02-01\")),\nPARTITION p202202 VALUES [(\"2022-02-01\"), (\"2022-03-01\")),\nPARTITION p202203 VALUES [(\"2022-03-01\"), (\"2022-04-01\")),\nPARTITION p202204 VALUES [(\"2022-04-01\"), (\"2022-05-01\")),\nPARTITION p202205 VALUES [(\"2022-05-01\"), (\"2022-06-01\")),\nPARTITION p202206 VALUES [(\"2022-06-01\"), (\"2022-07-01\")),\nPARTITION p202207 VALUES [(\"2022-07-01\"), (\"2022-08-01\")),\nPARTITION p202208 VALUES [(\"2022-08-01\"), (\"2022-09-01\")),\nPARTITION p202209 VALUES [(\"2022-09-01\"), (\"2022-10-01\")),\nPARTITION p202210 VALUES [(\"2022-10-01\"), (\"2022-11-01\")),\nPARTITION p202211 VALUES [(\"2022-11-01\"), (\"2022-12-01\")),\nPARTITION p202212 VALUES [(\"2022-12-01\"), (\"2023-01-01\")),\nPARTITION p202301 VALUES [(\"2023-01-01\"), (\"2023-02-01\")),\nPARTITION p202302 VALUES [(\"2023-02-01\"), (\"2023-03-01\")),\nPARTITION p202303 VALUES [(\"2023-03-01\"), (\"2023-03-31\")),\nPARTITION p20230331 VALUES [(\"2023-03-31\"), (\"2023-04-01\")),\nPARTITION p20230401 VALUES [(\"2023-04-01\"), (\"2023-04-02\")),\nPARTITION p20230402 VALUES [(\"2023-04-02\"), (\"2023-04-03\")),\nPARTITION p20230403 VALUES [(\"2023-04-03\"), (\"2023-04-04\")),\nPARTITION p20230404 VALUES [(\"2023-04-04\"), (\"2023-04-05\")),\nPARTITION p20230405 VALUES [(\"2023-04-05\"), (\"2023-04-06\")),\nPARTITION p20230406 VALUES [(\"2023-04-06\"), (\"2023-04-07\")),\nPARTITION p20230407 VALUES [(\"2023-04-07\"), (\"2023-04-08\")),\nPARTITION p20230408 VALUES [(\"2023-04-08\"), (\"2023-04-09\")),\nPARTITION p20230409 VALUES [(\"2023-04-09\"), (\"2023-04-10\")),\nPARTITION p20230410 VALUES [(\"2023-04-10\"), (\"2023-04-11\")),\nPARTITION p20230411 VALUES [(\"2023-04-11\"), (\"2023-04-12\")),\nPARTITION p20230412 VALUES [(\"2023-04-12\"), (\"2023-04-13\")),\nPARTITION p20230413 VALUES [(\"2023-04-13\"), (\"2023-04-14\")),\nPARTITION p20230414 VALUES [(\"2023-04-14\"), (\"2023-04-15\")),\nPARTITION p20230415 VALUES [(\"2023-04-15\"), (\"2023-04-16\")),\nPARTITION p20230416 VALUES [(\"2023-04-16\"), (\"2023-04-17\")),\nPARTITION p20230417 VALUES [(\"2023-04-17\"), (\"2023-04-18\")),\nPARTITION p20230418 VALUES [(\"2023-04-18\"), (\"2023-04-19\")),\nPARTITION p20230419 VALUES [(\"2023-04-19\"), (\"2023-04-20\")),\nPARTITION p20230420 VALUES [(\"2023-04-20\"), (\"2023-04-21\")),\nPARTITION p20230421 VALUES [(\"2023-04-21\"), (\"2023-04-22\")),\nPARTITION p20230422 VALUES [(\"2023-04-22\"), (\"2023-04-23\")),\nPARTITION p20230423 VALUES [(\"2023-04-23\"), (\"2023-04-24\")),\nPARTITION p20230424 VALUES [(\"2023-04-24\"), (\"2023-04-25\")),\nPARTITION p20230425 VALUES [(\"2023-04-25\"), (\"2023-04-26\")),\nPARTITION p20230426 VALUES [(\"2023-04-26\"), (\"2023-04-27\")),\nPARTITION p20230427 VALUES [(\"2023-04-27\"), (\"2023-04-28\")),\nPARTITION p20230428 VALUES [(\"2023-04-28\"), (\"2023-04-29\")),\nPARTITION p20230429 VALUES [(\"2023-04-29\"), (\"2023-04-30\")),\nPARTITION p20230430 VALUES [(\"2023-04-30\"), (\"2023-05-01\")),\nPARTITION p20230501 VALUES [(\"2023-05-01\"), (\"2023-05-02\")),\nPARTITION p20230502 VALUES [(\"2023-05-02\"), (\"2023-05-03\")),\nPARTITION p20230503 VALUES [(\"2023-05-03\"), (\"2023-05-04\")),\nPARTITION p20230504 VALUES [(\"2023-05-04\"), (\"2023-05-05\")),\nPARTITION p20230505 VALUES [(\"2023-05-05\"), (\"2023-05-06\")),\nPARTITION p20230506 VALUES [(\"2023-05-06\"), (\"2023-05-07\")),\nPARTITION p20230507 VALUES [(\"2023-05-07\"), (\"2023-05-08\")),\nPARTITION p20230508 VALUES [(\"2023-05-08\"), (\"2023-05-09\")),\nPARTITION p20230509 VALUES [(\"2023-05-09\"), (\"2023-05-10\")),\nPARTITION p20230510 VALUES [(\"2023-05-10\"), (\"2023-05-11\")),\nPARTITION p20230511 VALUES [(\"2023-05-11\"), (\"2023-05-12\")),\nPARTITION p20230512 VALUES [(\"2023-05-12\"), (\"2023-05-13\")),\nPARTITION p20230513 VALUES [(\"2023-05-13\"), (\"2023-05-14\")),\nPARTITION p20230514 VALUES [(\"2023-05-14\"), (\"2023-05-15\")),\nPARTITION p20230515 VALUES [(\"2023-05-15\"), (\"2023-05-16\")),\nPARTITION p20230516 VALUES [(\"2023-05-16\"), (\"2023-05-17\")),\nPARTITION p20230517 VALUES [(\"2023-05-17\"), (\"2023-05-18\")),\nPARTITION p20230518 VALUES [(\"2023-05-18\"), (\"2023-05-19\")),\nPARTITION p20230519 VALUES [(\"2023-05-19\"), (\"2023-05-20\")),\nPARTITION p20230520 VALUES [(\"2023-05-20\"), (\"2023-05-21\")),\nPARTITION p20230521 VALUES [(\"2023-05-21\"), (\"2023-05-22\")),\nPARTITION p20230522 VALUES [(\"2023-05-22\"), (\"2023-05-23\")),\nPARTITION p20230523 VALUES [(\"2023-05-23\"), (\"2023-05-24\")),\nPARTITION p20230524 VALUES [(\"2023-05-24\"), (\"2023-05-25\")),\nPARTITION p20230525 VALUES [(\"2023-05-25\"), (\"2023-05-26\")),\nPARTITION p20230526 VALUES [(\"2023-05-26\"), (\"2023-05-27\")),\nPARTITION p20230527 VALUES [(\"2023-05-27\"), (\"2023-05-28\")),\nPARTITION p20230528 VALUES [(\"2023-05-28\"), (\"2023-05-29\")),\nPARTITION p20230529 VALUES [(\"2023-05-29\"), (\"2023-05-30\")),\nPARTITION p20230530 VALUES [(\"2023-05-30\"), (\"2023-05-31\")),\nPARTITION p20230531 VALUES [(\"2023-05-31\"), (\"2023-06-01\")),\nPARTITION p20230601 VALUES [(\"2023-06-01\"), (\"2023-06-02\")),\nPARTITION p20230602 VALUES [(\"2023-06-02\"), (\"2023-06-03\")),\nPARTITION p20230603 VALUES [(\"2023-06-03\"), (\"2023-06-04\")),\nPARTITION p20230604 VALUES [(\"2023-06-04\"), (\"2023-06-05\")),\nPARTITION p20230605 VALUES [(\"2023-06-05\"), (\"2023-06-06\")),\nPARTITION p20230606 VALUES [(\"2023-06-06\"), (\"2023-06-07\")),\nPARTITION p20230607 VALUES [(\"2023-06-07\"), (\"2023-06-08\")),\nPARTITION p20230608 VALUES [(\"2023-06-08\"), (\"2023-06-09\")),\nPARTITION p20230609 VALUES [(\"2023-06-09\"), (\"2023-06-10\")),\nPARTITION p20230610 VALUES [(\"2023-06-10\"), (\"2023-06-11\")),\nPARTITION p20230611 VALUES [(\"2023-06-11\"), (\"2023-06-12\")),\nPARTITION p20230612 VALUES [(\"2023-06-12\"), (\"2023-06-13\")),\nPARTITION p20230613 VALUES [(\"2023-06-13\"), (\"2023-06-14\")),\nPARTITION p20230614 VALUES [(\"2023-06-14\"), (\"2023-06-15\")),\nPARTITION p20230615 VALUES [(\"2023-06-15\"), (\"2023-06-16\")),\nPARTITION p20230616 VALUES [(\"2023-06-16\"), (\"2023-06-17\")),\nPARTITION p20230617 VALUES [(\"2023-06-17\"), (\"2023-06-18\")),\nPARTITION p20230618 VALUES [(\"2023-06-18\"), (\"2023-06-19\")),\nPARTITION p20230619 VALUES [(\"2023-06-19\"), (\"2023-06-20\")),\nPARTITION p20230620 VALUES [(\"2023-06-20\"), (\"2023-06-21\")),\nPARTITION p20230621 VALUES [(\"2023-06-21\"), (\"2023-06-22\")),\nPARTITION p20230622 VALUES [(\"2023-06-22\"), (\"2023-06-23\")),\nPARTITION p20230623 VALUES [(\"2023-06-23\"), (\"2023-06-24\")),\nPARTITION p20230624 VALUES [(\"2023-06-24\"), (\"2023-06-25\")),\nPARTITION p20230625 VALUES [(\"2023-06-25\"), (\"2023-06-26\")),\nPARTITION p20230626 VALUES [(\"2023-06-26\"), (\"2023-06-27\")),\nPARTITION p20230627 VALUES [(\"2023-06-27\"), (\"2023-06-28\")),\nPARTITION p20230628 VALUES [(\"2023-06-28\"), (\"2023-06-29\")),\nPARTITION p20230629 VALUES [(\"2023-06-29\"), (\"2023-06-30\")),\nPARTITION p20230630 VALUES [(\"2023-06-30\"), (\"2023-07-01\")),\nPARTITION p20230701 VALUES [(\"2023-07-01\"), (\"2023-07-02\")),\nPARTITION p20230702 VALUES [(\"2023-07-02\"), (\"2023-07-03\")),\nPARTITION p20230703 VALUES [(\"2023-07-03\"), (\"2023-07-04\")),\nPARTITION p20230704 VALUES [(\"2023-07-04\"), (\"2023-07-05\")),\nPARTITION p20230705 VALUES [(\"2023-07-05\"), (\"2023-07-06\")),\nPARTITION p20230706 VALUES [(\"2023-07-06\"), (\"2023-07-07\")),\nPARTITION p20230707 VALUES [(\"2023-07-07\"), (\"2023-07-08\")),\nPARTITION p20230708 VALUES [(\"2023-07-08\"), (\"2023-07-09\")),\nPARTITION p20230709 VALUES [(\"2023-07-09\"), (\"2023-07-10\")),\nPARTITION p20230710 VALUES [(\"2023-07-10\"), (\"2023-07-11\")),\nPARTITION p20230711 VALUES [(\"2023-07-11\"), (\"2023-07-12\")),\nPARTITION p20230712 VALUES [(\"2023-07-12\"), (\"2023-07-13\")),\nPARTITION p20230713 VALUES [(\"2023-07-13\"), (\"2023-07-14\")),\nPARTITION p20230714 VALUES [(\"2023-07-14\"), (\"2023-07-15\")),\nPARTITION p20230715 VALUES [(\"2023-07-15\"), (\"2023-07-16\")),\nPARTITION p20230716 VALUES [(\"2023-07-16\"), (\"2023-07-17\")),\nPARTITION p20230717 VALUES [(\"2023-07-17\"), (\"2023-07-18\")),\nPARTITION p20230718 VALUES [(\"2023-07-18\"), (\"2023-07-19\")),\nPARTITION p20230719 VALUES [(\"2023-07-19\"), (\"2023-07-20\")))\nDISTRIBUTED BY HASH(`etl_dt`, `org_no`) BUCKETS 1 \nPROPERTIES (\n\"replication_num\" = \"1\",\n\"in_memory\" = \"false\",\n\"storage_format\" = \"DEFAULT\",\n\"enable_persistent_index\" = \"false\",\n\"compression\" = \"LZ4\"\n);",
    "test_db1.test_mv1": "CREATE MATERIALIZED VIEW `test_mv1` (`debit_crdt_flag`, `col2`, `etl_dt`, `sum_cvt_rmb_txn_amt`)\nPARTITION BY (etl_dt)\nDISTRIBUTED BY HASH(`etl_dt`, `col2`) BUCKETS 10 \nREFRESH MANUAL\nPROPERTIES (\n\"replication_num\" = \"1\",\n\"storage_medium\" = \"HDD\"\n)\nAS SELECT `p1`.`debit_crdt_flag`, `p1`.`col2`, `p1`.`etl_dt`, sum(`p1`.`cvt_rmb_txn_amt`) AS `sum_cvt_rmb_txn_amt`\nFROM `test_db1`.`tbl_1` AS `p1`\nGROUP BY 1, 2, 3;",
    "test_db1.test_mv2": "CREATE MATERIALIZED VIEW `test_mv2`\nPARTITION BY (etl_dt)\nDISTRIBUTED BY HASH(`etl_dt`, `col2`) BUCKETS 10 \nREFRESH MANUAL\nPROPERTIES (\n\"replication_num\" = \"1\",\n\"storage_medium\" = \"HDD\"\n)\nAS SELECT `test_db1`.`p1`.`col2`, `test_db2`.`p3`.`cust_cn_name`, `test_db1`.`p2`.`cust_mgr_name`, `test_db1`.`p1`.`col1`, `test_db1`.`p2`.`mgmt_org_name`, `test_db2`.`p4`.`org_no`, `test_db1`.`p1`.`etl_dt`, `test_db1`.`p1`.`debit_crdt_flag` AS `debit_crdt_flag1`, `test_db1`.`p5`.`debit_crdt_flag` AS `debit_crdt_flag2`, `test_db1`.`p5`.`sum_cvt_rmb_txn_amt`, sum(`test_db1`.`p1`.`cvt_rmb_txn_amt`) AS `cvt_rmb_txn_amt`\nFROM `test_db1`.`tbl_1` AS `p1` INNER JOIN `test_db1`.`test_mv1` AS `p5` ON `test_db1`.`p1`.`col2` = `test_db1`.`p5`.`col2` and `test_db1`.`p1`.`etl_dt` = `test_db1`.`p5`.`etl_dt`\nLEFT OUTER JOIN `test_db1`.`tbl_2` AS `p2` ON (((`test_db1`.`p2`.`cust_mgmt_type_cd` = '1') AND (`test_db1`.`p1`.`col2` = `test_db1`.`p2`.`col2`)) AND (`test_db1`.`p2`.`start_dt` <= `test_db1`.`p1`.`etl_dt`)) AND (`test_db1`.`p2`.`end_dt` > `test_db1`.`p1`.`etl_dt`) LEFT OUTER JOIN `test_db2`.`tbl_3` AS `p3` ON (`test_db1`.`p1`.`col2` = `test_db2`.`p3`.`col2`) AND (`test_db2`.`p3`.`etl_dt` = `test_db1`.`p1`.`etl_dt`) LEFT OUTER JOIN `test_db2`.`tbl_4` AS `p4` ON (`test_db1`.`p1`.`col1` = `test_db2`.`p4`.`acct_org_no`) AND (`test_db2`.`p4`.`etl_dt` = `test_db1`.`p1`.`etl_dt`)\nGROUP BY 1, 2, 3, 4, 5, 6, 7, 8, 9, 10;"
  },
  "table_row_count": {
    "test_db1.tbl_2": {
      "tbl_2": 397189747
    },
    "test_db1.test_mv1": {
      "test_mv1": 11299
    },
    "test_db2.tbl_3": {
      "p20230131": 7220621,
      "p20220228": 7220621,
      "p20221031": 7220621,
      "p20221130": 7220621,
      "p20220731": 7220621,
      "p20221231": 7220621,
      "p20220531": 7220621,
      "p20220630": 7220621,
      "p20201231": 7220621,
      "p20220331": 7220621,
      "p20220430": 7220621,
      "p20220131": 7220621,
      "p20220831": 7220621,
      "p20220930": 7220621,
      "p20230228": 7220621,
      "p20230630": 7220621,
      "p20211231": 7220621,
      "p20230331": 7220621
    },
    "test_db2.tbl_4": {
      "p20230529": 231,
      "p20230421": 231,
      "p20230531": 231,
      "p20230630": 231,
      "p20230331": 231,
      "p20230430": 231,
      "p20230530": 231
    },
    "test_db1.tbl_1": {
      "p20230331": 7019
    }
  },
  "session_variables": "{\"enable_show_all_variables\":false,\"cbo_cte_reuse\":false,\"full_sort_max_buffered_bytes\":16777216,\"character_set_connection\":\"utf8\",\"cbo_use_correlated_join_estimate\":true,\"enable_insert_strict\":true,\"enable_connector_adaptive_io_tasks\":true,\"tx_isolation\":\"REPEATABLE-READ\",\"wait_timeout\":28800,\"cbo_cte_reuse_rate\":1.2,\"enable_query_tablet_affinity\":false,\"transmission_encode_level\":7,\"query_including_mv_names\":\"\",\"character_set_results\":\"utf8\",\"transaction_isolation\":\"REPEATABLE-READ\",\"enable_global_runtime_filter\":true,\"load_transmission_compression_type\":\"NO_COMPRESSION\",\"cbo_enable_low_cardinality_optimize\":true,\"enable_resource_group_v2\":true,\"scan_use_query_mem_ratio\":0.3,\"query_excluding_mv_names\":\"\",\"new_planner_optimize_timeout\":3000,\"enable_realtime_mv\":false,\"enable_adaptive_sink_dop\":false,\"force_schedule_local\":false,\"hudi_mor_force_jni_reader\":false,\"full_sort_late_materialization\":false,\"enable_profile\":false,\"cbo_enable_greedy_join_reorder\":true,\"load_mem_limit\":0,\"sql_safe_updates\":0,\"runtime_filter_early_return_selectivity\":0.05,\"enable_local_shuffle_agg\":true,\"rpc_http_min_size\":2147482624,\"cbo_debug_alive_backend_number\":0,\"global_runtime_filter_probe_min_size\":102400,\"scan_or_to_union_limit\":1,\"select_ratio_threshold\":0.15,\"nested_mv_rewrite_max_level\":3,\"query_delivery_timeout\":300,\"net_write_timeout\":60,\"cbo_prune_shuffle_column_rate\":0.1,\"collation_database\":\"utf8_general_ci\",\"hash_join_push_down_right_table\":true,\"new_planner_agg_stage\":0,\"use_compute_nodes\":-1,\"collation_connection\":\"utf8_general_ci\",\"resource_group\":\"\",\"broadcast_row_limit\":15000000,\"enable_populate_block_cache\":true,\"profile_limit_fold\":true,\"exec_mem_limit\":2147483648,\"enable_sort_aggregate\":false,\"cbo_max_reorder_node_use_dp\":10,\"query_cache_force_populate\":false,\"runtime_filter_on_exchange_node\":false,\"disable_join_reorder\":false,\"enable_rule_based_materialized_view_rewrite\":true,\"enable_hive_column_stats\":true,\"enable_groupby_use_output_alias\":false,\"connector_scan_use_query_mem_ratio\":0.3,\"net_buffer_length\":16384,\"forward_to_leader\":false,\"count_distinct_column_buckets\":1024,\"full_sort_max_buffered_rows\":1024000,\"query_cache_agg_cardinality_limit\":5000000,\"query_timeout\":300,\"connector_io_tasks_slow_io_latency_ms\":50,\"enable_pipeline_query_statistic\":true,\"cbo_max_reorder_node\":50,\"cboPushDownAggregateMode_v1\":-1,\"window_partition_mode\":1,\"enable_deliver_batch_fragments\":true,\"enable_tablet_internal_parallel_v2\":true,\"enable_distinct_column_bucketization\":false,\"interpolate_passthrough\":true,\"runtime_filter_scan_wait_time\":20,\"SQL_AUTO_IS_NULL\":false,\"event_scheduler\":\"OFF\",\"prefer_compute_node\":false,\"enable_strict_type\":false,\"broadcast_right_table_scale_factor\":10,\"group_concat_max_len\":65535,\"disable_streaming_preaggregations\":false,\"enable_simplify_case_when\":true,\"parse_tokens_limit\":3500000,\"chunk_size\":4096,\"runtime_join_filter_push_down_limit\":1024000,\"global_runtime_filter_probe_min_selectivity\":0.5,\"query_mem_limit\":0,\"enable_filter_unused_columns_in_scan_stage\":false,\"enable_scan_block_cache\":false,\"enable_materialized_view_single_table_view_delta_rewrite\":false,\"div_precision_increment\":4,\"auto_increment_increment\":1,\"sql_mode_v2\":32,\"character_set_client\":\"utf8\",\"autocommit\":true,\"hdfs_backend_selector_scan_range_shuffle\":false,\"enable_column_expr_predicate\":true,\"pipeline_profile_level\":1,\"parallel_fragment_exec_instance_num\":1,\"max_scan_key_num\":-1,\"cbo_cte_max_limit\":10,\"net_read_timeout\":60,\"streaming_preaggregation_mode\":\"auto\",\"storage_engine\":\"olap\",\"hive_partition_stats_sample_size\":5000,\"enable_optimizer_trace_log\":false,\"enable_mv_planner\":false,\"cbo_enable_dp_join_reorder\":true,\"tx_visible_wait_timeout\":10,\"enable_materialized_view_view_delta_rewrite\":true,\"cbo_max_reorder_node_use_exhaustive\":4,\"enable_sql_digest\":false,\"profile_timeout\":2,\"cbo_push_down_aggregate\":\"global\",\"pipeline_dop\":4,\"enable_query_dump\":false,\"single_node_exec_plan\":false,\"join_implementation_mode_v2\":\"auto\",\"global_runtime_filter_build_max_size\":67108864,\"sql_select_limit\":9223372036854775807,\"enable_materialized_view_rewrite\":true,\"statistic_collect_parallel\":1,\"query_cache_hot_partition_num\":3,\"enable_prune_complex_types\":true,\"query_cache_type\":0,\"disable_colocate_join\":false,\"max_parallel_scan_instance_num\":-1,\"query_cache_entry_max_rows\":409600,\"max_pushdown_conditions_per_column\":-1,\"enable_mv_optimizer_trace_log\":false,\"connector_io_tasks_per_scan_operator\":16,\"enable_materialized_view_union_rewrite\":true,\"sql_quote_show_create\":true,\"scan_or_to_union_threshold\":50000000,\"enable_exchange_pass_through\":true,\"query_cache_entry_max_bytes\":4194304,\"innodb_read_only\":true,\"enable_exchange_perf\":false,\"enable_predicate_reorder\":false,\"workgroup_id\":0,\"enable_query_cache\":false,\"enable_rewrite_groupingsets_to_union_all\":false,\"transmission_compression_type\":\"LZ4\",\"interactive_timeout\":3600,\"max_allowed_packet\":1048576,\"collation_server\":\"utf8_general_ci\",\"time_zone\":\"Asia/Shanghai\",\"enable_multicolumn_global_runtime_filter\":false,\"character_set_server\":\"utf8\",\"tablet_internal_parallel_mode\":\"auto\",\"enable_pipeline\":true,\"cbo_use_nth_exec_plan\":0,\"io_tasks_per_scan_operator\":4,\"parallel_exchange_instance_num\":-1,\"enable_shared_scan\":false,\"enable_query_debug_trace\":false,\"allow_default_partition\":false}",
  "column_statistics": {
    "test_db1.tbl_2": {
      "start_dt": "[1.4832864E9, 1.681056E9, 0.0, 4.0, 2309.0] ESTIMATE",
      "end_dt": "[1.4833728E9, 3.25351008E10, 0.0, 4.0, 2298.0] ESTIMATE",
      "cust_mgr_name": "[-Infinity, Infinity, 0.0, 9.347668463355374, 2889.0] ESTIMATE",
      "cust_mgmt_type_cd": "[-Infinity, Infinity, 0.0, 1.0000001409905477, 3.0] ESTIMATE",
      "col2": "[-Infinity, Infinity, 0.0, 10.0, 6.4291068E7] ESTIMATE",
      "mgmt_org_name": "[-Infinity, Infinity, 0.0, 8.418374782468893, 795.0] ESTIMATE"
    },
    "test_db1.test_mv1": {
      "sum_cvt_rmb_txn_amt": "[-Infinity, Infinity, 0.0, 1.0, 1.0] UNKNOWN",
      "col2": "[-Infinity, Infinity, 0.0, 1.0, 1.0] UNKNOWN",
      "debit_crdt_flag": "[-Infinity, Infinity, 0.0, 1.0, 1.0] UNKNOWN"
    },
    "test_db2.tbl_3": {
      "cust_cn_name": "[-Infinity, Infinity, 0.0, 30.87139053796689, 2.978105E7] ESTIMATE",
      "col2": "[-Infinity, Infinity, 0.0, 10.0, 6.6145172E7] ESTIMATE",
      "etl_dt": "[1.609344E9, 1.6880544E9, 0.0, 4.0, 18.0] ESTIMATE"
    },
    "test_db2.tbl_4": {
      "acct_org_no": "[-Infinity, Infinity, 0.0, 3.960393675721562, 374.0] ESTIMATE",
      "etl_dt": "[1.680192E9, 1.6880544E9, 0.0, 4.0, 7.0] ESTIMATE",
      "org_no": "[-Infinity, Infinity, 0.0, 7.948190789473684, 3215.0] ESTIMATE"
    },
    "test_db1.tbl_1": {
      "col1": "[-Infinity, Infinity, 0.0, 4.0, 257.0] ESTIMATE",
      "col2": "[-Infinity, Infinity, 0.0, 10.0, 9482.0] ESTIMATE",
      "etl_dt": "[1.680192E9, 1.680192E9, 0.0, 4.0, 1.0] ESTIMATE",
      "debit_crdt_flag": "[-Infinity, Infinity, 0.0, 2.0, 2.0] ESTIMATE",
      "cvt_rmb_txn_amt": "[-2000000.0, 2.03E8, 0.0, 16.0, 3655.0] ESTIMATE"
    }
  },
  "be_number": 3,
  "be_core_stat": {
    "numOfHardwareCoresPerBe": "{\"10002\":16,\"10003\":16,\"10004\":16}",
    "cachedAvgNumOfHardwareCores": -1
  },
  "exception": [],
  "version": "2.5.10",
  "commit_version": "9feb716"
}